SupplierItemReceivingUnitConversionRule

Entity Definition

Logical Name : SupplierItemReceivingUnitConversionRule
Physical Name : RU_CVN_SPR_ITM_UN

Defines a conversion rule to explode a higher level material receiving unit into a lower level. For example a pallet may be exploded into 24 cases and each case may be exploded into 24 retail sale units. Each of these conversions is defined in a conversion rule entity type instance

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
parent (FK)(PK) A category of container that defines what it is made of, its type (primarily its material handling category - e.g. 55 gallon drums, pallets, cases, etc.) and its shape. CD_CNR_TYP_PRNT Code varchar(20) SupplierItemReceivingUnit(AS_UNI_SPR_ITM_RCV)
child (FK)(PK) A category of container that defines what it is made of, its type (primarily its material handling category - e.g. 55 gallon drums, pallets, cases, etc.) and its shape. CD_CNR_TYP_CHLD Code varchar(20) SupplierItemReceivingUnit(AS_UNI_SPR_ITM_RCV)
ConversionFactorCount The number of units within each shipment container. This factor is multiplied by the number of containers to provide the total number of units. FA_FCT_CVN Quantity DECIMAL(9,3)
ConversionToRetailSaleUnitCount The number of retail units calculated by multiplying the conversion factor count and the number of containers. FA_SL_CVN_TO_RT Quantity DECIMAL(9,3)

Relationships

Parent Entity Verb Phrase Child Entity
SupplierItemReceivingUnit contains SupplierItemReceivingUnitConversionRule
SupplierItemReceivingUnit is exploded into SupplierItemReceivingUnitConversionRule

Logical Views containing SupplierItemReceivingUnitConversionRule

Logical View
Logical 01500 - Item Supplier View
Logical 01501 - Item Unit of Measure Types
Logical 02130 - Item Inventory - Receiving View